USE [PetShopBBOM]

if not exists (select * from master.dbo.syslogins where loginname = N'alice')
BEGIN
	CREATE LOGIN alice WITH PASSWORD = 'alice',
       CHECK_POLICY = OFF
END

exec sp_grantdbaccess 'alice'

exec sp_addrolemember 'db_owner', 'alice'

